package com.base.mapper.voipmapper;

import com.base.po.sqlparam.ShopAliOrderExamplePage;
import com.base.po.voip.ShopAliOrder;
import com.base.po.voip.ShopAliOrderExample;
import com.base.utils.Page;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface ShopAliOrderMapper {
	int countByExample(ShopAliOrderExample example);

	int countByUserID(@Param("userid") String userid);

	int deleteByExample(ShopAliOrderExample example);

	int deleteByPrimaryKey(String id);

	int insert(ShopAliOrder record);

	int insertSelective(ShopAliOrder record);

	List<ShopAliOrder> selectByExample(ShopAliOrderExample example);

	List<ShopAliOrder> selectByExamplePage(ShopAliOrderExamplePage example);

	List<ShopAliOrder> selectByUserID(@Param("page") Page page, @Param("userid") String userid);

	List<ShopAliOrder> selectByAll(@Param("userid") String userid, @Param("status1") Integer status1,
                                   @Param("status2") Integer status2);

	String selectByOrdernum(@Param("orderNum") String orderNum);

	ShopAliOrder selectByPrimaryKey(String id);

	ShopAliOrder selectByOrderNum(String ordernum);

	int updateByExampleSelective(@Param("record") ShopAliOrder record, @Param("example") ShopAliOrderExample example);

	int updateByExample(@Param("record") ShopAliOrder record, @Param("example") ShopAliOrderExample example);

	int updateByPrimaryKeySelective(ShopAliOrder record);

	int updateByPrimaryKey(ShopAliOrder record);

	int updateByOrderNum(@Param("status") Integer status, @Param("ordernum") String ordernum);

	int updateByorderNum(@Param("clicktime") Date clicktime, @Param("jsmoney") BigDecimal jsmoney,
                         @Param("status") Integer status, @Param("ordernum") String ordernum);
}